IBExpert Day Edition

(German-language version below)

The IBExpert Day Edition contains all the features of the IBExpert IDE, e.g. debugger, performance analysis and much more.

IBExpert can be used on registered computers for 24 hours following activation. After the 24 hour period IBExpert will no longer start on this computer, but can be activated again.

Use IBExpert wherever you or your employees work

In the home office
For customer support
On customer computers, e.g. as a supplement to the Company Year Edition

The automatic termination after 24 hours minimizes the risk of running an unlicensed product on customer machines.

Or for other tasks

Benchmark tests
Training purposes
Tests

Also as a cost-effective introduction

For your trainees and interns
And of course also for testing for new customers

And also at hand in case of emergency

For short-term use on another computer, e.g. if you cannot generate a removal code when moving to another computer, or your computer is broken.

IBExpert Day Edition Packages

There are a number of IBExpert Day Edition Packages. Please refer to our IBExpert products, services & prices page for details.

Please register in the IBExpert Download Center for this product with a valid e-mail address. If possible, use a use a company address such as support@companyx.com, ibexpertday@computerenterprise.com or similar.

The software activations are made available on your user account in the IBExpert Download Center for a period of 12 months.

Afterwards any unused activations will automatically expire. To prevent this, you can purchase a new IBExpert Day Edition package before the expiry date, so that unused activations are credited for a further 12 months.

The IBExpert Day Edition is the ideal supplement to all IBExpert full versions, ready for use on all computers at any time.

The IBExpert Day Edition can also be run on Linux/Wine.

You can download the latest IBExpert IDE setup file from the IBExpert Download Center and distribute it with your software product. If you wish to work with IBExpert on your customer servers, activate one of your Day Editions with your e-mail address/password combination to start IBExpert.

---

IBExpert Day Edition

Die IBExpert Day Edition enthält alle Funktionen der IBExpert IDE, z.B. Debugger, Performanceanalyse u.v.m.

IBExpert kann nach der Freischaltung 24 Stunden auf dem Computer benutzt werden. Nach Ablauf von 24 Stunden wird IBExpert auf diesem Computer nicht mehr starten, kann aber erneut wieder freigeschaltet werden.

Benutzen Sie IBExpert überall dort, wo Sie oder Ihre Mitarbeiter arbeiten:

Im Office
Im Homeoffice
Im Kundensupport
Auf Kundenrechnern, z.B. als Ergänzung zur Company Year Edition

Durch das automatische Beenden nach 24 Stunden minimiert sich das Risiko, ein nicht lizenziertes Produkt auf Kundenrechnern zu betreiben

Oder für andere Aufgaben

Für Benchmarktests
Für Schulungszwecke
Für Tests

Auch als günstiger Einstieg

Für Ihre Auszubildenden und Praktikanten
Und natürlich auch zum Testen für Neukunden

Und auch im Notfall zur Hand

Für den kurzfristigen Einsatz auf einem anderen Computer, z.B., wenn Sie keinen Removal Code beim Umzug auf einen anderen Computer erzeugen können, oder Ihr Computer defekt ist.

IBExpert Day Edition Pakete

Es gibt eine Auswahl an IBExpert Day Edition Paketen. Bitte entnehmen Sie die Details unserer IBExpert Produkte, Dienstleistungen & Preise-Seite.

Bitte registrieren Sie sich im IBExpert Download Center für dieses Produkt mit einer gültigen E-Mail-Adresse. Verwenden Sie nach Möglichkeit eine Firmenadresse wie z.B.support@companyx.com, ibexpertday@computerenterprise.de oder ähnliches.

Die Freischaltung erfolgt auf Ihrem User Account im IBExpert Download Center für den Zeitraum von 12 Monaten.

Nicht angeforderten Aktivierungen verfallen danach automatisch. Um dieses zu verhindern, können Sie rechtzeitig vor Ablauf ein neues IBExpert Day Edition Paket erwerben, damit werden nicht angeforderte Aktivierungen für die nächsten 12 Monate gutgeschrieben.

Die IBExpert Day Edition ist die ideale Ergänzung zu allen IBExpert Vollversionen, jederzeit auf allen Computern einsatzbereit.

Die IBExpert Day Edition ist auch mit Linux/Wine lauffähig.

Sie können die aktuelle IBExpert IDE-Setup-Datei im IBExpert Download Center herunterladen und mit Ihrem Software-Produkt verteilen. Wenn Sie mit IBExpert auf Ihren Kundenservern arbeiten möchten, aktivieren Sie eine Ihrer Day Editions mit Ihrer E-Mail-Adresse/Passwort Kombination, um IBExpert zu starten.

Current IBExpert version

View all new features of version 2026.07.26 here: What's New  

Whats New

IBExpert 2026.07.26

This version includes further adaptations and optimisations to new Firebird 6 features, along with minor bugfixes and improvements.

---

IBExpert 2026.02.22

(and bugfixes 2026.03.01/2026.03.04/2026.03.15/2026.13.19/2026.03.31/2026.04.02/2026.05.22/2026.05.26/2026.05.28/2026.06.02)

The main improvement in this version is support for schemas in the Extract Metadata engine and everything around it: the Extract metadata feature itself, the ibec_ExtractMetadata function and other places where pFIBExtract is used. 

---

IBExpert 2025.08.04

(and bugfixes 2025.08.08/2025.10.29/2025.10.31/2025.11.07/2025.11.12/
2025.11.17/2025.12.19/2025.12.23)

1. SQL Editor

• Support for CALL statement (FB 6).
• Support for SHOW (WIRE_STATISTICS | WIRE_STATS) command (FB 6).
  The command show values of wire statistics counters, accumulated since the connection start time.

2. Database Inside

• Initial support for FB 6 databases.

3. New trace session form

• "Initial view mode" option implemented.

4. Other minor bugfixes and improvements

---

IBExpert 2025.06.09

(and bugfixes 2025.06.18/2025.06.24)

1. Initial support for Firebird 6 implemented

2. Blob editor

• Improvement: Two or more blob editors can now be opened at the same time.
  To start a second, third etc. blob editor use the "New blob editor" button in an already opened blob editor.

3. SQL Editor

• Improvement (Firebird 6): EXPLAIN <query> 
  - Prepares <query> and gets its plan in the usual way.
  - Executes "select * from rdb$sql.explain(<query>)" and shows results in the data grid.

4. DB Explorer

• Bugfix: Missing colorization of incremental search results if the database connection charset is UTF8.

5. IBEBlock

• Bugfix: ibec_CompareMetadata ignored stored functions and packages if Firebird 4.0 or Firebird 5.0 is specified as the server version. 
• Improvement: FOR loop now supports DOWNTO and BY clauses similar to Firebird 6 syntax.

6. Minor bugfixes and small improvements

---

IBExpert 2024.12.01

(and bugfixes 2024.12.04/2025.02.05/2025.02.27/2025.03.07/2025.03.28/2025.04.22/2025.05.08)

1. Event blocks

• "Before start trace session" event block implemented.
  See \Blocks\Templates\EventBlocks\TAS.BeforeStartTraceSession.ibeblock for an example.
  Also see description of new "Quick start trace session" feature below.

2. Code editors

• Support for multilevels in User actions submenu.
  See \Blocks\Templates\EventBlocks\CodeEditorUserActions.ibeblock for a working example.

3. Database Comparer

• Fixed the problem with missing stored functions and packages while comparing Firebird 5 databases.

4. Quick start trace session feature implemented

• This feature is intended to start a trace session for an active connection with a single click.
• Default trace config is provided by IBExpert and can be modified in the "Before start trace session" event block which is fired when quick start or regular start (Services | Trace and Audit | Start new trace session) is performed.
  
  There are several other properties of trace session and trace form which can be customized in the "Before start trace session" event block.
  
  See \Blocks\Templates\EventBlocks\TAS.BeforeStartTraceSession.ibeblock for complete example.

• To quick start a trace session, use the corresponding button on the main form tool button. Alternatively it can be done using the [Ctrl] + [Shift] + [T] shortcut.

5. IBEBlock

• ibec_psql_PreprocessPSQL function implemented.
  
  It inserts some placeholders in the form of single line comments into a provided PSQL source (procedures, functions, triggers and package routines) which can be later replaced with additional debug statements (INSERT into a log table etc.). For a complete example see \Blocks\DefaultBlocks\PSQL.PrepareForDebug.ibeblock.
  
  There is also a working implementation of calling this block from \Blocks\Templates\EventBlocks\ CodeEditorUserActions.ibeblock which performs the preparation of the PSQL source for debugging and removes debug statements and comments from the PSQL source when they are no longer needed.

• @SysUtils.GetFilePath function implemented.
  
  The function sequentially checks the specified folders for the presence of the file. If the folder contains the specified file, the function returns the full path to it and exits. Otherwise, it returns NULL.

Example:

    ...

    sBlockFileName = 'PSQL.PrepareForDebug.ibeblock';
    sBlockFilePath = @SysUtils.GetFilePath(sBlockFileName,
       ibec_GetEnvironmentVariable('IBE_USERBLOCKSDIR'),
       ibec_Coalesce(ibec_GetEnvironmentVariable('IBE_APPDIR'), '') + '\Blocks\DefaultBlocks');

    if (sBlockFilePath is null) then
    begin
      ibec_ShowMessage('Looks like ''' + sBlockFileName + '''is missing...');
      Exit;
    end; 

6. Minor bugfixes and small improvements

---

IBExpert 2024.04.07

1. Database Registration

"Show server version mismatch warning" option added (Additional tab). 

If this option is ON (default) IBExpert will compare the specified and the actual version of the database and warn in case of a mismatch with a choice of possible actions.

2. PSQL Debugger

Support for time zones implemented (Firebird 4, 5). 

3. Data Grids

The possibility to dump blobs to file without preloading them into the IBExpert GUI has been implemented; it is available from the grid context menu.

Fixed the issue with incorrect representation of RDB$DB_KEY for tables with >2G records. 

4. Code Completion

Fixed the incorrect behaviour when selecting/unselecting items in the list using the mouse. 

5. Database Inside

Support for Firebird 5 databases. 

6. SQL Editor, Statements History List

Added counters for page operations. 

7. Database Comparer

Support for parenthesized SELECTs (Firebird 5) implemented. 

8. Other minor bugfixes and small improvements

---

IBExpert 2024.01.22

Mainly bug fixes.

---

IBExpert 2023.11.22

Mainly bug fixes.

---

IBExpert 2023.10.27

1. Code Editor, Code Completion

• Improved performance especially on databases with lot of objects.
• Suggesting possible joins based on existing relationships by foreign keys - call the Code Completion after JOIN keyword.
• There was a bug on some configurations in the previous version which caused IBExpert to freeze when the Code Completion is fires. Fixed in this version.

2. Database Inside

• Support for Firebird 4 databases.

3. Partial support for Firebird 5 implemented

• Support for all known syntax changes/additions in the PSQL parser:

     SKIP LOCKED, WHEN NOT MATCHED BY SOURCE, parenthesized SELECTs etc.

     However, there is NO support yet for parenthesized SELECTs in the Database Comparer.
     Also the PSQL debugger doesn't allow to debug roitines with subroutines which reference variables in a main routine.

• Support for new built-in functions in the Code Parameters hint.
• Support for partial indices in the index editors and metadata extract.
• Support for parallel workers in following IBEBlock functions:

    ibec_BackupDatabase, ibec_RestoreDatabase, @Services.RepairDatabase.

      There is a new option available - ParallelWorkers (or just Parallel) - which allows to specify number of parallel workers (e.g. ParallelWorkers=4)

4. Other minor bugfixes and small improvements

---

IBExpert 2023.09.13

Mainly bug fixes.

---

IBExpert 2023.07.09

1. DB Explorer

•   Activating/deactivating database objects from the Project View tree.

2. Search in Metadata

•   Possibility to search in scripts/blocks (IBE$SCRIPTS table) has been implemented.

3. Code Editors

•  Hyperlinks behaviour for package routines implemented.
• "Before load from file" event block implemented. This block allows you to perform some actions before the appearance of the "Open file" dialog; for example, change a source directory. See block template for more details.
• "Init/perform user actions" event block implemented. This block allows you to define user actions with code editor content which will be executed via a shortcut and/or from the code editor context menu (the very first item in the menu, if the block exists and is active). See block template for more details.

4. Dependencies trees

•   Solved some issues with the incorrect display of package dependencies.

5. Copy Database Object

• Support of SQL role in copy blocks added.

6. IBEBlock

• @Services.RepairDatabase and @Services.SetDBProperties functions implemented. 

    Example:

    execute ibeblock

    as
    begin
      -- Both functions return nothing (NULL) if there were no errors, 
      -- otherwise they will return an error message 

      sDBName = 'dbserver/3053:D:\databases\db.fdb';
      sConnectParams = 'ClientLib="D:\ClientLibs\fbclient_30.dll"; User=SYSDBA; Password=masterkey;';

      -- Supported repair params: Limbo, CheckDB, IgnoreChecksum, 
      -- KillShadows, Mend, Sweep, Validate, ValidateFull

      Res = @Services.RepairDatabase(:sDBName, :sConnectParams || 'Mend');

      if (Res is not null) then
        ibec_ShowMessage(Res); 

      -- All supported params are listed in the example

      Res = @Services.SetDBProperties(:sDBName, :sConnectParams || 'PageBuffers=2048; SQLDialect=3;
            SweepInterval=20000; ForcedWrites=TRUE; ReadOnly=FALSE');

      if (Res is not null) then
        ibec_ShowMessage(Res);

    end;

• ibec_ExtractMetadata function:
  ExtractPrimaryKeys and ExtractUniques options added to prevent extraction of primary keys and unique constraints. Together with the existing ExtractReferences and ExtractChecks these options allow you to suppress the extraction of all constraints.
  
  By default all of these options are ON (TRUE). To disable the extraction of primary keys, for example, set the corresponding option to FALSE: ExtractPrimaryKeys=FALSE.
  
  
• Code Editor namespace with set of functions implemented. See example of usage in the "Init/perform user actions" event block template.

7. Minor bugfixes and small improvements

---

IBExpert 2023.04.14

Minor bugfixes and small improvements.

---

IBExpert 2023.03.06

 1. Data Grid

• Possibility to edit UUID/OCTETS values in the filter criteria tree has been implemented.
• The mouse wheel can now be used to perform Page Up and Page Down actions.
• By default the Ctrl key should be held to perform PageUp/PageDown.
• To change the default modifier put the following piece of code into the After IBExpert starts event block:

    ibec_SetGlobalVar('IBE$DATA_GRID_PAGE_SCROLL_MODIFIER', <value>);

        where <value> is one of following: empty string, null, 'CTRL', 'ALT', 'SHIFT'.

        An empty string or null as a new modifier value makes PageDown/PageUp a default                behaviour of the mouse wheel in the Data Grid.

2. Code Editor

• Support of keyboard templates in the Code Completion list.
  There is a new option Show keyboard templates in Code Completion list in the Options | Editor Options | Code Insight.

3. Automatic restore of a dead connection

• By default if the database connection is lost IBExpert shows a dialog window and offers to restore a dead connection. To attempt to restore the connection automatically without user confirmation put following line of code into the After IBExpert starts event block:

    ibec_SetGlobalVar('IBE$RESTORE_DEAD_CONNECTION', TRUE);

4. Database Object Editors

• Support of object names longer than 31 chars (Firebird 4) where they were not yet supported.

5. Export Data

• Export to clipboard in JSON format implemented.

6. Code Formatter

• Support of space after opening and before closing bracket options.

7. Minor bugfixes and small improvements

Monitoring

(German-language version below)

IBExpert Firebird SQL Performance Monitoring
Your way out of the blind alley

The situation

---

IBExpert Firebird SQL Performance Monitoring
Ihr Ausweg aus der Sackgasse

IBExpert & Firebird Prepaid Hotline

(German-language version below)

---

IBExpert und Firebird Prepaid Hotline

IBEScript – Firebird-Skripte automatisiert ausführen

Mit IBEScript lassen sich Firebird-Skripte komfortabel über die Windows-Kommandozeile automatisiert ausführen. Das eigenständige Kommandozeilen-Tool eignet sich ideal für geplante Aufgaben, Installationsroutinen, Batch-Dateien und CI/CD-Prozesse – ganz ohne grafische Benutzeroberfläche.

Die Abbildung zeigt die aktuelle Hilfeausgabe der 64-Bit-Windows-Version von IBEScript 2026.07.29.00.

Bereits der Aufruf von ibescr64.exe zeigt alle verfügbaren Kommandozeilenoptionen, darunter Funktionen für Protokollierung, Fehlerbehandlung, Verbindungen und Skriptverschlüsselung.

Automatisierung von Datenbankprozessen

IBEScript befindet sich im IBExpert-Installationsverzeichnis und kann direkt über die Kommandozeile gestartet werden. Dadurch lassen sich wiederkehrende Aufgaben zuverlässig automatisieren, beispielsweise:

• Erstellung und Einrichtung von Firebird-Datenbanken
• Ausführung von Update- und Wartungsskripten
• Datenmigrationen
• automatisierte Reports und Exporte
• Integration in Installations- und Deployment-Prozesse

Die grundlegende Syntax:

IBEScript script_filename [options]

Beispiel:

IBEScript C:\Scripts\CreateDB.sql

Umfangreiche Steuerungsmöglichkeiten

IBEScript bietet zahlreiche Optionen zur Kontrolle der Skriptausführung:

• ausführliche Ablaufprotokolle und Fehlerausgaben
• Speicherung von Logdateien mit Zeitstempel
• Fortschrittsanzeige bei umfangreichen Skripten
• flexible Übergabe von Verbindungsparametern
• Verschlüsselung und Schutz von Skriptdateien

Leistungsfähige IBEBlock-Unterstützung

Durch die integrierte IBEBlock-Technologie können auch komplexe Datenbankoperationen automatisiert durchgeführt werden.

Mögliche Einsatzbereiche:

• Übertragung von Daten zwischen mehreren Firebird- oder InterBase®-Datenbanken
• Zugriff auf externe ODBC-Datenquellen wie Microsoft Access®, Oracle® oder IBM DB2®
• Vergleich und Synchronisation von Datenbankstrukturen über ibec_CompareMetadata
• automatisierte Erstellung von Reports aus dem IBExpert Report Manager

Zusätzlich unterstützt IBEScript den Import und Export von Dateien in Datenbankfeldern, beispielsweise für BLOB-Daten, sowie die Verwendung von Umgebungsvariablen für flexible Installationen.

Fazit

IBEScript erweitert IBExpert um eine leistungsfähige Kommandozeilen-Schnittstelle für professionelle Datenbankautomatisierung.

Von einfachen SQL-Ausführungen bis hin zu komplexen Migrationen, Datenbankvergleichen und automatisierten Reports bietet IBEScript alle Werkzeuge, um Firebird-Prozesse effizient und zuverlässig zu steuern.

IBEScript ist damit eine ideale Ergänzung für Entwickler, Administratoren und Unternehmen, die wiederkehrende Datenbankaufgaben automatisieren möchten.

Hinweis: IBEScript ist Bestandteil von IBExpert und steht in dieser Form nicht in der kostenlosen IBExpert Personal Edition zur Verfügung.